package com.qf.mapper;

import com.qf.entity.Emp;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.sql.SQLException;
import java.util.List;

/**
 * User: key
 * ClassName:EmpDao
 * Date: 2023/5/25
 * Time: 16:35
 * description:
 */
public interface EmpMapper {
    public List<Emp> selectAll() throws SQLException;

    public Emp select(Emp emp) throws SQLException;
    public Emp select(Integer eno) throws SQLException;
    public List<Emp> selectByEnos(@Param(value = "list") List<Integer> list) throws SQLException;
    public Emp selectBy(@Param(value = "ename") String ename,@Param(value = "pwd") String pwd) throws SQLException;

    public Integer insert(Emp emp) throws SQLException;

    public Integer update(Emp emp) throws SQLException;

    public Integer delete(Integer eno) throws SQLException;

    public List<Emp> updateBench(List<Emp> list);

    Integer deleteByIds(List<Emp> emp);

}
